06. Solutions: Window Functions 2

Creating a Partitioned Running Total Using Window Functions

SELECT standard_amt_usd,
       DATE_TRUNC('year', occurred_at) as year,
       SUM(standard_amt_usd) OVER (PARTITION BY DATE_TRUNC('year', occurred_at) ORDER BY occurred_at) AS running_total
FROM orders

If you'd like another example of partitioning, check out the top answer from this Stack Overflow post:
“Partition By” Keyword